2013-03-15 - 5910.200 - Enhancement - Contract Reports Development #CrystalReportDevelopment
ENHANCEMENT
5910.200 - To modify all OSA and SA reports to include contracts
Requirement Summary
Need to include Contract Quantity and Contract Revenue in all OSA, SA Reports and Other Reports specified by NEC.
Admin Info
Purpose
|
To modify all OSA and SA reports to include contracts.
|
Requested By
|
Mark Harris
|
Spec Created By
|
Mallareddy D
|
Spec Created Date
|
03/15/2013
|
Spec QA by
|
Uday Kumar P
|
Objects
|
Reports Listed below
|
Document Status
|
Complete
|
References
Prior Tickets
5910.300
5910.400
5910.500
Documents
Contract scope.xlsx
Add-Contracts.pdf
More specs.pdf
Functional Requirement
1) Reports need to include Open Reference Quantity of contract in Open Quantity and Open Reference Revenue of contract in Open Revenue.
2) Need to replace transactional attributes with navigational attributes in BEx queries.
3) Need to include Prepack Conversions in BEx queries as applicable.
4) Need to avoid currency conversion files used in crystal reports if there is no currency conversion parameter and include it in BEx queries.
5) Need to check each report with NEC Crystal Reports standard checklist.
6) The following reports need to be changed:
SNo
|
Report Name
|
01
|
EPM199
|
02
|
EPM200
|
03
|
EPM210
|
04
|
EPM220
|
05
|
EPM230
|
06
|
EPM240
|
07
|
OSA100
|
08
|
OSA110
|
09
|
OSA130
|
10
|
OSA131
|
11
|
OSA132
|
12
|
OSA175
|
13
|
OSA180
|
14
|
OSA181
|
15
|
OSA350
|
16
|
OSA900
|
17
|
OSA905
|
18
|
OSA910
|
19
|
OSA915
|
20
|
INV300
|
21
|
INV310
|
22
|
SA110
|
23
|
SA115
|
24
|
SA120
|
25
|
SA130
|
26
|
SA140
|
27
|
SA150
|
28
|
SA160
|
29
|
SA170
|
30
|
SA200
|
31
|
SA210
|
32
|
SA215
|
33
|
SA220
|
34
|
SA230
|
35
|
SA231
|
36
|
OpenorderssubreportScorecard
|
37
|
OSA920
|
Solution Summary
1) Need to create BEx Queries and update the same in Crystal reports.
2) Need to create a new Multiprovider and the BEx queries on it to satisfy some report requirements.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1
|
Need to check reports format against NEC Crystal Reports standard checklist.
|
Crystal Reports Format should comply standard checklist.
|
2
|
Need to validate the reports in each level against BEx queries.
|
Report values should match with BEx Query values.
|
Solution Details
1) Need to create BEx queries which has to include the Open Reference Qty of contract in Open Qty and Open Reference Revenue of contract in Open Revenue.
2) Update BEx query in corresponding Crystal Report.
3) Validate the resport as per test plan above.
Issues
1) Some reports require a new multiprovider to be designed based on open order and contract cube.
2) Inventory reports cannot include the contract information, so need to exclude INV300 and INV310 from development.